package fr.enseirb.mycub.db;

import android.provider.BaseColumns;

public class BikeDBConstants extends DBConstants{
	
	// table pour les velos
		public static final String BIKE_STATION_TABLE = "bike_stations";
		
		public static final String KEY_BIKES = "availableBikes";
		public static final String KEY_SLOTS = "freeSlots";

	public static final String CREATE_BIKE_STATIONS_TABLE = "create table "
			+ BIKE_STATION_TABLE + " (" + BaseColumns._ID + " integer not null, "
			+ KEY_NAME + " text not null COLLATE NOCASE, " + KEY_OPEN
			+ " integer not null, " + KEY_BIKES + " integer not null, "
			+ KEY_SLOTS + " integer not null, " + KEY_ADDRESS
			+ " text not null COLLATE NOCASE, " + KEY_LATITUDE
			+ " integer not null, " + KEY_LONGITUDE + " integer not null, "
			+ KEY_FAVORITE
			+ " integer not null, " + KEY_PAYMENT + " integer not null, "
			+ KEY_SPECIAL + " integer not null );";

}
